In this video we are going to learn how to enter data and formulas into what worksheet and bring data
in a cell is very simple.
We just clicked the cell and tied the data into it.
Let's see how.
Let's click on cell B1
when you click it.
This take black model box highlights the cell.
This means that this cell is now active.
If I want to activate C1 I will click on Stevens said I can also use keyboard arrow keys to move it
on this active cell.
If I press down key active cell now becomes C2.
If I press right key data becomes the active cell and what is the meaning of being active.
If a cell is active whatever you will type on your keyboard will be entered in that active cell only.
So I want to write columns and cell B2 I click on cell we do or use the arrow keys to navigate to sell
we and then start typing columns
then embrace the data key on the keyboard.
I am on Cell C to No no let slide sixteen thousand three hundred eighty four which is the total number
of columns in a worksheet
similarly left and the rows in beat reason
the number of roses one million forty eight thousand five hundred seventy six.
If you remember in the last video I asked if you know the number of rules and number of columns can
you find out the number of cells in this sheet.
Let us find out the number of cells by writing cells in the cell
and writing the formula for calculating cells.
The formula will be simply the product of numbers in Cell C C2 and seventy three.
That is if we multiply the number of columns with number of rows we get the number of cells to enter
a formula.
We start with equal to symbol.
Then we click on the cell which contains the first value.
Then we put the multiplication symbol which is a start and then we select the second cell
when I click enter.
This is the number that I get.
This is the number of cells in a worksheet.
All these mathematical symbols such as the multiplication symbol that we use here and other mathematical
formulas will be discussed in depth in the coming reduce head.
I've just used the multiplication symbol as an example for you.
Now you can see that this cell has the value of the number of cells but you can also see the formula
that you entered in this bar.
This bar is called the formula bar the formula bar shows the content of the active cell active cell
can have both data or a formula in it.
If it has data the data will be shown in the formula but if it has a formula the answer of the formula
will be shown in this cell.
However the actual formula will be shown in the formula bar on the left of this formula bar is the Name
Box name box tells us the name of the active cell.
So right now are active LSC 4 and that is the name we are shown in the Name Box.
You can see the name is C for C stands for the column name and for stands for the row name.
So now you have created this worksheet which has some data into it.
You would like to see if this worksheet.
So that whenever you open it again you access the same data to save a worksheet.
We use the file button in this.
You will see options such as new open saves a vase etc..
Since we are saving this file for the first time we will click on save us and we will select the location
where we want to save this file.
I'm saving this file on my desktop.
I'm naming the file as Excel basics.
You can see that the tape is selected as Excel workbook which has a default extension of DOT Excel S6
every excel file that you'll save by default will have a file extension of DOT Excel ethics if you want
to change the location of where you are saving this way you can navigate the location using these navigation
folders or you can enter the location on this top but also know where to click save.
You can see that the name of my workbook is changed to excel basic dot Excel is x.
If I minimize this file and go to my desktop
you can see that I have this file named Excel basic dot excellence x.
And whenever I double click on this file these same file will open up once I'll file is saved in its
location whenever you make any changes to it you can just press this save button or you can go to file
option and click on Save.
Now let's close this file once and open it again.
Using this saved file icon you can see that your file was successfully saved.
You can open it anytime and work on it again whenever you feel like.